package cn.chinaunicom.sdsi.gacx.contractMng.dao.mybatis;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import cn.chinaunicom.sdsi.gacx.contractMng.entity.TravelContractModelEntity;

public interface TravelContractModelMapper {

	@Select("select * from travel_contract_model where contract_name like concat('%',#{contractName},'%')")
	public List<TravelContractModelEntity> qryTrlContMdlList(@Param("contractName") String contractName);
	
	public void saveContractTmp(TravelContractModelEntity tcme);
	
	@Delete("delete from travel_contract_model where contract_id = #{contractId}")
	public int delTrlContMdlById(@Param("contractId") String contractId);
	
	@Select("select count(1) from travel_contract_model where contract_name = #{contractName}")
	public int qryTrlContMdlByName(@Param("contractName") String contractName);
	
	@Select("select * from travel_contract_model where contract_id = #{contractId}")
	public TravelContractModelEntity qryTrvlTmpMdlById(String contractId);
}
